/*
 Navicat Premium Data Transfer

 Source Server         : 裴亚辉阿里云
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : 120.77.213.159:3306
 Source Schema         : mxshop_usr_srv

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 03/06/2021 13:28:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
                        `id` int(11) NOT NULL AUTO_INCREMENT,
                        `password` varchar(100) NOT NULL,
                        `nick_name` varchar(20) DEFAULT NULL,
                        `head_url` varchar(200) DEFAULT NULL,
                        `birthday` date DEFAULT NULL,
                        `address` varchar(200) DEFAULT NULL,
                        `desc` text,
                        `gender` varchar(6) DEFAULT NULL,
                        `role` int(11) NOT NULL,
                        `mobile` varchar(12) NOT NULL,
                        PRIMARY KEY (`id`),
                        UNIQUE KEY `user_mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '$pbkdf2-sha256$29000$rPWeM4awNsZYK6U0Rggh5A$U4vBU.lngsrTlPOCiHVYoh5uvV7AMtTSs1qeewHVCIY', 'peiyahui0', NULL, NULL, NULL, NULL, NULL, 2, '13999189290');
INSERT INTO `user` VALUES (2, '$pbkdf2-sha256$29000$wHjP2ZvT.r93DqEUAmBsbQ$wDA/cf1GFQpUpedT..5NgEFK5gak3O0FBkdnFwDJNjA', 'peiyahui1', NULL, NULL, NULL, NULL, NULL, 1, '13999189291');
INSERT INTO `user` VALUES (3, '$pbkdf2-sha256$29000$t/beO4ewlvL.3zvH2Ls3Jg$TT1FCi0Iq9P64cm61/DsUEMuJQvybwpS83TrZr.98As', 'peiyahui2', NULL, NULL, NULL, NULL, NULL, 1, '13999189292');
INSERT INTO `user` VALUES (4, '$pbkdf2-sha256$29000$HiMkhFCKsbZ2jlEKQYjRWg$qFVnoDvCFYz8QZLINWzktPl7.wf7bxtENoh7qTQ8lS8', 'peiyahui3', NULL, NULL, NULL, NULL, NULL, 1, '13999189293');
INSERT INTO `user` VALUES (5, '$pbkdf2-sha256$29000$x1hLKcW41zpHCIEQYgwh5A$m1r1xb6zuy.JjftaitQsnjT.3wT57lUwRkXB4atZHWc', 'peiyahui4', NULL, NULL, NULL, NULL, NULL, 1, '13999189294');
INSERT INTO `user` VALUES (6, '$pbkdf2-sha256$29000$Semd01qLEYKwFsL4X4vR2g$Heo4eCP0Yl94Sn79MMcZB8dzuUpRSSM1RMvktRkP.Uk', 'peiyahui5', NULL, NULL, NULL, NULL, NULL, 1, '13999189295');
INSERT INTO `user` VALUES (7, '$pbkdf2-sha256$29000$s7ZWCmEs5fzf.7/XWuu9Nw$W8o4Qpsky9GMox3LZpQPYGUFsFWOZAQkj4C6a4nJXDA', 'peiyahui6', NULL, NULL, NULL, NULL, NULL, 1, '13999189296');
INSERT INTO `user` VALUES (8, '$pbkdf2-sha256$29000$kTJGCMEY4/xfq/X.H.Nc6w$xqNPC1WuXymNuG84LI06aWFnxZSVQ/RNhQGEpacEEzs', 'peiyahui7', NULL, NULL, NULL, NULL, NULL, 1, '13999189297');
INSERT INTO `user` VALUES (9, '$pbkdf2-sha256$29000$rxVirFUqpZTS.n.PMSYkhA$79YLku4KshyBhFFq4vo4/Q6O6ogqIfO8/EOkBzPe9ZM', 'peiyahui8', NULL, NULL, NULL, NULL, NULL, 1, '13999189298');
INSERT INTO `user` VALUES (10, '$pbkdf2-sha256$29000$UgphbG2N8T7n3LsXohSC0A$d5XYvLOuW5CsF/i5OoyEJEJdDyMniDeErTyQ.45bRS4', 'peiyahui9', NULL, NULL, NULL, NULL, NULL, 1, '13999189299');
INSERT INTO `user` VALUES (11, '', 'Jinzhu', '', '2021-06-02', 'XXXX', 'DescDesc', '123', 1, '123456');
INSERT INTO `user` VALUES (18, '', '1231231', '', '2021-06-02', 'XXXX12', 'DescDesc12', '12312', 1, '12345678911');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
